UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZ2km+iB1NugLGASSNoqlN5SkkNo2J5XydAwEtAV+dc='
WHERE
key_id = '5d7c58c83f8ba668cf4f6ea7e066d138561079cab4de57da9bcb997a6175d115'
AND (
token = 'pZ2km+iB1NugLGASSNoqlN5SkkNo2J5XydAwEtAV+dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)