UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bx2X8b+YCSlD/kBaFuZzNV5EJgaeGOVsOg7y4Xdb/1k=' 
WHERE 
  key_id = '39b35b968e72b5136bb9e2600688af43b61a7d00f69d40403ae5b0c1de528b8b' 
  AND (
    token = 'bx2X8b+YCSlD/kBaFuZzNV5EJgaeGOVsOg7y4Xdb/1k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053