UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'w+L6vny7R7cinV/5zH+bUNhw8YF1Pyjl0QAT6ESNw/s=' 
WHERE 
  key_id = '678359c7d14f9cf9bac1104a1c5acda58e41578bb356e7ff3b08225217bacdcc' 
  AND (
    token = 'w+L6vny7R7cinV/5zH+bUNhw8YF1Pyjl0QAT6ESNw/s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00055