UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4pS5rBl7u5266tMwqlGiRHhZG7hqvo2zcBUP7mtyxw='
WHERE
key_id = 'f320a3fa335aa07f58b4889b9f21a27122b1243e8b14b014b3d4a6e704d68b32'
AND (
token = 'a4pS5rBl7u5266tMwqlGiRHhZG7hqvo2zcBUP7mtyxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)