UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WSBqDZctNloGiSir+f4hyYFRmyk3IgJ4p4cANv0NOrA='
WHERE
key_id = '3a5927857842e6d4b58c7eefef2d6b5ab49e655ca1807545e2ccd40c8f86a1c0'
AND (
token = 'WSBqDZctNloGiSir+f4hyYFRmyk3IgJ4p4cANv0NOrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)