UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47on5oXWOogmXTFyE+ohkrCFSW31++8EywbumYWquoY='
WHERE
key_id = '8ffdab970e6edcd9d5ad056ccb6898906384b1b07a1285b3e9c35c6f6b1f2eb5'
AND (
token = '47on5oXWOogmXTFyE+ohkrCFSW31++8EywbumYWquoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)