UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8E2nGa0Nd5rr3IS4NkurFDAVBeNwYW6l7ckVNFV+QiQ='
WHERE
key_id = '47ce2194d235f5fa4441cc080e1132523792e6bc4df8e4d8282f497b8c914a0e'
AND (
token = '8E2nGa0Nd5rr3IS4NkurFDAVBeNwYW6l7ckVNFV+QiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)