UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99wIKp1DuFqXmSUkBFNRYcq6o0XFiDOFlXNt8I649pQ='
WHERE
key_id = '8c0b2aeff9717378593abb7203cf3fb1b5b4ef38dc3136ad04d277ef5943642d'
AND (
token = '99wIKp1DuFqXmSUkBFNRYcq6o0XFiDOFlXNt8I649pQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)