UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pa1JdZR0rsCm5JArO861ViSsQC363S7eVZrV5SuLW4='
WHERE
key_id = 'f8bfb2204482412a7486663f1fd2ae903306d2f1482cc43f6002c24b88d4fd14'
AND (
token = '8pa1JdZR0rsCm5JArO861ViSsQC363S7eVZrV5SuLW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)