UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jg7foYs+PdXcyjnf9vFQ9doQ03Rk6Ec6l5h8UfDYHg8='
WHERE
key_id = 'c6ac64fa32215c6f6c6852b5582e942cc3b2fd3d8b1a1e80b044a55890c7ddc9'
AND (
token = 'jg7foYs+PdXcyjnf9vFQ9doQ03Rk6Ec6l5h8UfDYHg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)