UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fnj1cjY5Ad2NeEhTq3VmJp1s0AZ6pqf0N9k94wYFjJs='
WHERE
key_id = '8ec5c4f6cc59aeb7f2975c40e25893ee30e4e0b5bf23c5ddb4007161e0efd50b'
AND (
token = 'fnj1cjY5Ad2NeEhTq3VmJp1s0AZ6pqf0N9k94wYFjJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)