UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uYOyx27QuI9YhNHH2URNIW2uPE6bafrdaoLPfOHmZ0E='
WHERE
key_id = '249f8ade3e3f1370709b42869205cecc6b3de031f4a8ea2f3be5e9ac9941a100'
AND (
token = 'uYOyx27QuI9YhNHH2URNIW2uPE6bafrdaoLPfOHmZ0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)