UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZq0XrMg/hU3S9Y/X2RwUWqxOb7P8jNTsjBF9lzaeHU='
WHERE
key_id = '6ab0340f8b3e848478bb4c8de8f4bd83a03c630fe486e9b909192d1ad3ac186a'
AND (
token = 'vZq0XrMg/hU3S9Y/X2RwUWqxOb7P8jNTsjBF9lzaeHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)