UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgYflRUjjC+I/NdjDhkIxH+NDrRkeaB9ti0u7Ur2WN0='
WHERE
key_id = '81978ba85d8a1a0b464f1f6a04f684f121e2514ab8cf5f02f4b87a167f842acf'
AND (
token = 'ZgYflRUjjC+I/NdjDhkIxH+NDrRkeaB9ti0u7Ur2WN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)