UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZh5q3YRmWt1nkW19z5qVEMSg1I0vuRn9/biTPP6yAE='
WHERE
key_id = '74e6fd9cd2ee52b6fff0e610a6dee4396153f2a220ecdcb6226a039369f90968'
AND (
token = 'xZh5q3YRmWt1nkW19z5qVEMSg1I0vuRn9/biTPP6yAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)