UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'diBkHJac/dpUYxVEI61qfRDW56pTfbw1xoS9O1VIoLg=' 
WHERE 
  key_id = '1fa540e8a39b3400d2c06f61d3476c0334d09081f699c03be11c8180538d16ad' 
  AND (
    token = 'diBkHJac/dpUYxVEI61qfRDW56pTfbw1xoS9O1VIoLg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028