UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9vZXrr0JD0d7kWeF62f9NLn+g/0kDkAcc47V0O772k='
WHERE
key_id = '40e09891c816b5130bd0aa6b3fba8fc6491317e4fbd01f2ba5fd96d35a880dba'
AND (
token = 'E9vZXrr0JD0d7kWeF62f9NLn+g/0kDkAcc47V0O772k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)