UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3QoWhWICbG9QaQj4LF9QQP2aE9toFTGnZXdDjimmiq8='
WHERE
key_id = '8271e4b542fed3fb5a458fddd862b5b8ad27d9686e6f0dcdb586f2191a6b341c'
AND (
token = '3QoWhWICbG9QaQj4LF9QQP2aE9toFTGnZXdDjimmiq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)