UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XxzVzrlM6OnXsP4QQqHqpuC15zb9CYSo/TfpFZIHiuM='
WHERE
key_id = 'bd185c54a2c9eac8d328b83ce55538937fecd8d0dbab8210df4dc44a8c7f3d89'
AND (
token = 'XxzVzrlM6OnXsP4QQqHqpuC15zb9CYSo/TfpFZIHiuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)