UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPFQhHFsqGAS+2c016Fh/JKlagEmOX2GufPi2HYGB9k='
WHERE
key_id = 'd9b80162a26a27a5870e5284bf3b3fa13197de674dcf238632f565e9f1e6f693'
AND (
token = 'sPFQhHFsqGAS+2c016Fh/JKlagEmOX2GufPi2HYGB9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)