UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHCmVptvU7SppKRlQB/334Wa48N6IGbVJlOdvVCdeUY='
WHERE
key_id = '3b119f74eedf948a14920d53bc98619ae3aabf623fba11206b6cf97706e682f8'
AND (
token = 'zHCmVptvU7SppKRlQB/334Wa48N6IGbVJlOdvVCdeUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)