UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ha+JtkkkfuaAASOykeJHdgICH7dHTGej5gdhP6a8DgQ='
WHERE
key_id = 'b3a1c877421f58b34ef4237f2c6597486800c86d2bb200275f10bf7d63c22d14'
AND (
token = 'Ha+JtkkkfuaAASOykeJHdgICH7dHTGej5gdhP6a8DgQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)