UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xLL5SfpCaHKcS2dhNCXkVWKChukb5NFhI4wO7dkTbCU='
WHERE
key_id = '0b5d29bd5ab2c95aacbe8f9b5aee7a3411cf3ef0fe7dc8c3a667b8780060743c'
AND (
token = 'xLL5SfpCaHKcS2dhNCXkVWKChukb5NFhI4wO7dkTbCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)