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