UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KGVJ7j5N5BCB0G2PCFynsrCT23JZQ6IX49q/I/OQaI='
WHERE
key_id = '02974b0fda91247b2fb63a9c7ec835066e83e9a50443c8ebb2314ceb5688d32a'
AND (
token = '/KGVJ7j5N5BCB0G2PCFynsrCT23JZQ6IX49q/I/OQaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)