UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TURsOPaUGPLh9nj3z0MiK7VL9TW/g0CiK+S4CKVR318='
WHERE
key_id = 'bd71df4cc6f0d38b1485ff5fcf89fa3bd078521a896266c9c21a4fe19695c676'
AND (
token = 'TURsOPaUGPLh9nj3z0MiK7VL9TW/g0CiK+S4CKVR318='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)