UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fuoQhYugjCKocRoiQojEirAN/QIPdHdG68r14lRQGJE='
WHERE
key_id = '2e2ebe47a7c790279f47dd5ea37eb5cbfe3140d0d7b408c5f19c92b15845b3f9'
AND (
token = 'fuoQhYugjCKocRoiQojEirAN/QIPdHdG68r14lRQGJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)