UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0QqQkCAiegL8ON51I0VT9CKpZ7/IfNvGrJ0NS1gjVio='
WHERE
key_id = '8ee2ec5f9a817212106e3cf553160d4de9ffa6110e974c85a0179b49d1e2b1fb'
AND (
token = '0QqQkCAiegL8ON51I0VT9CKpZ7/IfNvGrJ0NS1gjVio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)