UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZCZuto0S1i6iyaC+12gvZOuuX/iOhWZEqxnlLnvCho='
WHERE
key_id = '38b73b81677305a6cc6005726c1237efd1103e9bd86df9b1e59dd873293f43bb'
AND (
token = 'dZCZuto0S1i6iyaC+12gvZOuuX/iOhWZEqxnlLnvCho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)