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