UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3v2+0RDNgtCgD0odq9Zoh4eyDZsplc0cTu5jsKuX0Xo=' 
WHERE 
  key_id = '7b09a6b8ef6371a7f7809cd9d32ce7b07373d66aa787b43553494f25c4cff5da' 
  AND (
    token = '3v2+0RDNgtCgD0odq9Zoh4eyDZsplc0cTu5jsKuX0Xo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037