UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQnU54ohf1rmTKiLD6xMA7K5KsMVnINrfsM3fMrE+9w='
WHERE
key_id = '31fc11a09841b717a20c2ae1a7b1ed058a1d5d55714b221f24486a21d36bad77'
AND (
token = 'zQnU54ohf1rmTKiLD6xMA7K5KsMVnINrfsM3fMrE+9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)