UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's7NEfT1KcmPwJfWVCVmZphtVB3WAi/da6rqxvEyxBDA='
WHERE
key_id = '9d77ac45c7cbf0597e47a34144d99a3c9dec79a35ee2ffd1b4c3651e769b9703'
AND (
token = 's7NEfT1KcmPwJfWVCVmZphtVB3WAi/da6rqxvEyxBDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)