UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pVOGvZBrO8UQbCYxCo8PY+61lK4Jf7zHc4Q8Hj7odQs=' 
WHERE 
  key_id = 'e18af901be25ee093a9bcdc2aca89d215d1b3f7d1032b03e3b5ccdff5dda782c' 
  AND (
    token = 'pVOGvZBrO8UQbCYxCo8PY+61lK4Jf7zHc4Q8Hj7odQs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024